﻿CREATE TABLE [dbo].[BookOfWorkClientVariance] (
    [PeriodYear]     SMALLINT        NOT NULL,
    [WeekNumber]     SMALLINT        NOT NULL,
    [Month]          SMALLINT        NOT NULL,
    [ReferenceDate]  DATE            NOT NULL,
    [ProgramId]      VARCHAR (30)    NOT NULL,
    [ProgramName]    VARCHAR (255)   NULL,
    [ProgramManager] VARCHAR (255)   NULL,
    [ProjectId]      VARCHAR (10)    NOT NULL,
    [ProjectName]    VARCHAR (200)   NULL,
    [BowFlag]        VARCHAR (10)    NOT NULL,
    [ClientLevel5]   VARCHAR (120)   NULL,
    [ClientLevel6]   VARCHAR (120)   NULL,
    [ClientLevel7]   VARCHAR (120)   NULL,
    [ClientGocCode]  VARCHAR (20)    NOT NULL,
    [LobParent]      VARCHAR (250)   NOT NULL,
    [PLFY0]          DECIMAL (38, 3) NULL,
    [Allocation0]    DECIMAL (38, 3) NULL,
    [PLFY1]          DECIMAL (38, 3) NULL,
    [Allocation1]    DECIMAL (38, 3) NULL,
    [PLFY2]          DECIMAL (38, 3) NULL,
    [Allocation2]    DECIMAL (38, 3) NULL,
    [PLFY3]          DECIMAL (38, 3) NULL,
    [Allocation3]    DECIMAL (38, 3) NULL,
    [PLFY4]          DECIMAL (38, 3) NULL,
    [Allocation4]    DECIMAL (38, 3) NULL,
    [PLFY5]          DECIMAL (38, 3) NULL,
    [Allocation5]    DECIMAL (38, 3) NULL
);



